This guide walks you through configuring and authenticating the MS SQL tools in Airia, enabling your agents to interact with your Microsoft SQL Server database. Airia provides the following MS SQL tools:
  • MS SQL Query Tool: To execute queries against your MS SQL database.
  • MS SQL Metadata Retrieval Tool: To retrieve schema metadata for your MS SQL database.
Both tools are required for comprehensive interaction with your MS SQL Database.

​
Supported MS SQL Versions

Airia currently supports the following versions of MS SQL:
  • Azure SQL Database
  • Azure Synapse Analytics
  • Azure SQL Managed Instance
  • SQL Server 2022
  • SQL Server 2019
  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014

​
Prerequisites

To connect Airia to your MS SQL server, you will need the following details:
  • Hostname/Endpoint
  • Port (default: 1433)
  • Database name
  • Basic Credentials:
    • User name
    • Password
💡 Note: These details can be retrieved from your MS SQL server. For example, if your server is hosted on Azure, connection details (such as the hostname) can often be found under the Connection Strings (specifically the ODBC tab) in the Azure portal. Your password will be server-specific.
Retrieve Ms. SQL connection details

​
Add and Configure MS SQL Tools

Follow these steps to add and configure each MS SQL tool:
  1. Add an MS SQL Tool:
    • Navigate to the Tools section in your Airia dashboard.
    • From the library, select the MS SQL tool you wish to add (e.g., MS SQL Query Tool or MS SQL Metadata Retrieval Tool).
  2. Provide Connection Details:
    • On the tool configuration page, provide the following details:
      • Hostname/Endpoint: Your MS SQL server’s hostname or IP address.
      • Port: The port number your MS SQL server is listening on (default 1433).
      • Database name: The name of the database you want to connect to.
    • For User name and Password, set them as a Basic authentication credential.
  3. Save the Tool:
    • Click Save to add the configured tool to your library.
  4. Repeat for Other Tool:
    • Repeat steps 1-3 for the MS SQL Metadata Retrieval Tool, providing the same connection values.

​
Next Steps

Now that your MS SQL tools are added, you can integrate them into an agent to query your MS SQL database.
⚠️ Warning: Your MS SQL server must be accessible by Public IP. If you encounter connectivity issues, contact support@airia.com. We can provide you with the necessary IP addresses to whitelist on your firewall.